SELECT DISTINCT
T.Udstr_cd AS Udstr_cd,
T.Udstr_Desc_Cn AS Udstr_Desc_Cn,
T.Dealer_Type AS Dealer_Type,
CASE WHEN T.DD_Date IS NULL THEN GETDATE() ELSE T.DD_Date END AS DD_Date,
T.CoopBu AS CoopBu,
T.RenewBu AS RenewBu,
0 AS IsPass,
GETDATE() AS CreateDate
FROM  Sqllnk_simsqa.cs.masterdata.T_DDRnew_Alert_New T